SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_alumnospilquen
AS
SELECT     distinct TOP 100 PERCENT va.Documento, va.Apellidos, va.Nombres, va.Documento AS Expr1, dt.Mnemo, ad.AnioLectivo
FROM         dbo.tb_Divisionestemp dt INNER JOIN
                      dbo.tb_AlumnoDivision ad ON ad.Division = dt.idDivision INNER JOIN
                      dbo.vistaalumnosentre4y14 va ON va.idAlumno = ad.Alumno
ORDER BY va.Documento, ad.AnioLectivo


GO
